<?php

class ShellController extends Controller
{
	/**
	 * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
	 * using two-column layout. See 'protected/views/layouts/column2.php'.
	 */
	public $layout='//layouts/column2';

	/**
	 * @return array action filters
	 */
	public function filters()
	{
		return array(
			//'accessControl', // perform access control for CRUD operations
		);
	}

	/**
	 * Specifies the access control rules.
	 * This method is used by the 'accessControl' filter.
	 * @return array access control rules
	 */
	public function accessRules()
	{
		return array(
			array('allow',  // allow all users to perform 'index' and 'view' actions
				'actions'=>array('index','admin'),
				'users'=>array('*'),
			),
			array('allow', // allow authenticated user to perform 'create' and 'update' actions
				'actions'=>array('create','update'),
				'users'=>array('@'),
			),
			array('allow', // allow admin user to perform 'admin' and 'delete' actions
				'actions'=>array('admin','delete'),
				'users'=>array('admin'),
			),
			array('deny',  // deny all users
				'users'=>array('*'),
			),
		);
	}

	public function actionUpper(){
		$connection = Yii::app()->db;
		$sql = "select * from nc_user where user_id != ". Yii::app()->user->id ." order by issue_num DESC limit 10";
		$user = $connection->createCommand($sql)->queryAll();
		if(!empty($user)){
			foreach($user as $key=>$value){
				/*
				$upper = new Upper();
				$upper->upper_user_id = $value['user_id'];
				$upper->upper_user_name = $value['user_name'];
				$upper->user_id = Yii::app()->user->id;
				$upper->user_name = Yii::app()->user->name;
				$upper->upper_time = time();
				$upper->save();	
				*/
				Upper::addUpper($value['user_id']);
			}
		}
	}
	public function actionFans(){
		$connection = Yii::app()->db;
		$sql = "select * from nc_user where user_id != ". Yii::app()->user->id ." limit 50";
		$user = $connection->createCommand($sql)->queryAll();
		if(!empty($user)){
			foreach($user as $key=>$value){
				$fans = new fans();
				$fans->fans_user_id = $value['user_id'];
				$fans->fans_user_name = $value['user_name'];
				$fans->user_id = Yii::app()->user->id;
				$fans->user_name = Yii::app()->user->name;
				$fans->fans_time = time();
				$fans->save();	
			}
		}
	}
	/**
	 * Returns the data model based on the primary key given in the GET variable.
	 * If the data model is not found, an HTTP exception will be raised.
	 * @param integer the ID of the model to be loaded
	 */
	public function loadModel($id)
	{
		$model=Upper::model()->findByPk((int)$id);
		if($model===null)
			throw new CHttpException(404,'The requested page does not exist.');
		return $model;
	}

	
}
